package com.strato.saas.merchant.v1_0_0.jdbc.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MerchantInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MerchantInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("merchant_id is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("merchant_id is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(String value) {
            addCriterion("merchant_id =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(String value) {
            addCriterion("merchant_id <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(String value) {
            addCriterion("merchant_id >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("merchant_id >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(String value) {
            addCriterion("merchant_id <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("merchant_id <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLike(String value) {
            addCriterion("merchant_id like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotLike(String value) {
            addCriterion("merchant_id not like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<String> values) {
            addCriterion("merchant_id in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<String> values) {
            addCriterion("merchant_id not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(String value1, String value2) {
            addCriterion("merchant_id between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(String value1, String value2) {
            addCriterion("merchant_id not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNull() {
            addCriterion("company_code is null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNotNull() {
            addCriterion("company_code is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeEqualTo(String value) {
            addCriterion("company_code =", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotEqualTo(String value) {
            addCriterion("company_code <>", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThan(String value) {
            addCriterion("company_code >", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("company_code >=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThan(String value) {
            addCriterion("company_code <", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("company_code <=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLike(String value) {
            addCriterion("company_code like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotLike(String value) {
            addCriterion("company_code not like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIn(List<String> values) {
            addCriterion("company_code in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotIn(List<String> values) {
            addCriterion("company_code not in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeBetween(String value1, String value2) {
            addCriterion("company_code between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("company_code not between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordIsNull() {
            addCriterion("company_password is null");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordIsNotNull() {
            addCriterion("company_password is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordEqualTo(String value) {
            addCriterion("company_password =", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordNotEqualTo(String value) {
            addCriterion("company_password <>", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordGreaterThan(String value) {
            addCriterion("company_password >", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("company_password >=", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordLessThan(String value) {
            addCriterion("company_password <", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordLessThanOrEqualTo(String value) {
            addCriterion("company_password <=", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordLike(String value) {
            addCriterion("company_password like", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordNotLike(String value) {
            addCriterion("company_password not like", value, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordIn(List<String> values) {
            addCriterion("company_password in", values, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordNotIn(List<String> values) {
            addCriterion("company_password not in", values, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordBetween(String value1, String value2) {
            addCriterion("company_password between", value1, value2, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andCompanyPasswordNotBetween(String value1, String value2) {
            addCriterion("company_password not between", value1, value2, "companyPassword");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeIsNull() {
            addCriterion("last_send_active_email_time is null");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeIsNotNull() {
            addCriterion("last_send_active_email_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeEqualTo(Date value) {
            addCriterion("last_send_active_email_time =", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeNotEqualTo(Date value) {
            addCriterion("last_send_active_email_time <>", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeGreaterThan(Date value) {
            addCriterion("last_send_active_email_time >", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_send_active_email_time >=", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeLessThan(Date value) {
            addCriterion("last_send_active_email_time <", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_send_active_email_time <=", value, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeIn(List<Date> values) {
            addCriterion("last_send_active_email_time in", values, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeNotIn(List<Date> values) {
            addCriterion("last_send_active_email_time not in", values, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeBetween(Date value1, Date value2) {
            addCriterion("last_send_active_email_time between", value1, value2, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andLastSendActiveEmailTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_send_active_email_time not between", value1, value2, "lastSendActiveEmailTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeIsNull() {
            addCriterion("active_time is null");
            return (Criteria) this;
        }

        public Criteria andActiveTimeIsNotNull() {
            addCriterion("active_time is not null");
            return (Criteria) this;
        }

        public Criteria andActiveTimeEqualTo(Date value) {
            addCriterion("active_time =", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeNotEqualTo(Date value) {
            addCriterion("active_time <>", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeGreaterThan(Date value) {
            addCriterion("active_time >", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("active_time >=", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeLessThan(Date value) {
            addCriterion("active_time <", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeLessThanOrEqualTo(Date value) {
            addCriterion("active_time <=", value, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeIn(List<Date> values) {
            addCriterion("active_time in", values, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeNotIn(List<Date> values) {
            addCriterion("active_time not in", values, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeBetween(Date value1, Date value2) {
            addCriterion("active_time between", value1, value2, "activeTime");
            return (Criteria) this;
        }

        public Criteria andActiveTimeNotBetween(Date value1, Date value2) {
            addCriterion("active_time not between", value1, value2, "activeTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andConnUrlIsNull() {
            addCriterion("conn_url is null");
            return (Criteria) this;
        }

        public Criteria andConnUrlIsNotNull() {
            addCriterion("conn_url is not null");
            return (Criteria) this;
        }

        public Criteria andConnUrlEqualTo(String value) {
            addCriterion("conn_url =", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlNotEqualTo(String value) {
            addCriterion("conn_url <>", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlGreaterThan(String value) {
            addCriterion("conn_url >", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlGreaterThanOrEqualTo(String value) {
            addCriterion("conn_url >=", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlLessThan(String value) {
            addCriterion("conn_url <", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlLessThanOrEqualTo(String value) {
            addCriterion("conn_url <=", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlLike(String value) {
            addCriterion("conn_url like", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlNotLike(String value) {
            addCriterion("conn_url not like", value, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlIn(List<String> values) {
            addCriterion("conn_url in", values, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlNotIn(List<String> values) {
            addCriterion("conn_url not in", values, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlBetween(String value1, String value2) {
            addCriterion("conn_url between", value1, value2, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUrlNotBetween(String value1, String value2) {
            addCriterion("conn_url not between", value1, value2, "connUrl");
            return (Criteria) this;
        }

        public Criteria andConnUsrIsNull() {
            addCriterion("conn_usr is null");
            return (Criteria) this;
        }

        public Criteria andConnUsrIsNotNull() {
            addCriterion("conn_usr is not null");
            return (Criteria) this;
        }

        public Criteria andConnUsrEqualTo(String value) {
            addCriterion("conn_usr =", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrNotEqualTo(String value) {
            addCriterion("conn_usr <>", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrGreaterThan(String value) {
            addCriterion("conn_usr >", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrGreaterThanOrEqualTo(String value) {
            addCriterion("conn_usr >=", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrLessThan(String value) {
            addCriterion("conn_usr <", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrLessThanOrEqualTo(String value) {
            addCriterion("conn_usr <=", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrLike(String value) {
            addCriterion("conn_usr like", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrNotLike(String value) {
            addCriterion("conn_usr not like", value, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrIn(List<String> values) {
            addCriterion("conn_usr in", values, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrNotIn(List<String> values) {
            addCriterion("conn_usr not in", values, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrBetween(String value1, String value2) {
            addCriterion("conn_usr between", value1, value2, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnUsrNotBetween(String value1, String value2) {
            addCriterion("conn_usr not between", value1, value2, "connUsr");
            return (Criteria) this;
        }

        public Criteria andConnPwdIsNull() {
            addCriterion("conn_pwd is null");
            return (Criteria) this;
        }

        public Criteria andConnPwdIsNotNull() {
            addCriterion("conn_pwd is not null");
            return (Criteria) this;
        }

        public Criteria andConnPwdEqualTo(String value) {
            addCriterion("conn_pwd =", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdNotEqualTo(String value) {
            addCriterion("conn_pwd <>", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdGreaterThan(String value) {
            addCriterion("conn_pwd >", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdGreaterThanOrEqualTo(String value) {
            addCriterion("conn_pwd >=", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdLessThan(String value) {
            addCriterion("conn_pwd <", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdLessThanOrEqualTo(String value) {
            addCriterion("conn_pwd <=", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdLike(String value) {
            addCriterion("conn_pwd like", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdNotLike(String value) {
            addCriterion("conn_pwd not like", value, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdIn(List<String> values) {
            addCriterion("conn_pwd in", values, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdNotIn(List<String> values) {
            addCriterion("conn_pwd not in", values, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdBetween(String value1, String value2) {
            addCriterion("conn_pwd between", value1, value2, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnPwdNotBetween(String value1, String value2) {
            addCriterion("conn_pwd not between", value1, value2, "connPwd");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeIsNull() {
            addCriterion("conn_initsize is null");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeIsNotNull() {
            addCriterion("conn_initsize is not null");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeEqualTo(Integer value) {
            addCriterion("conn_initsize =", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeNotEqualTo(Integer value) {
            addCriterion("conn_initsize <>", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeGreaterThan(Integer value) {
            addCriterion("conn_initsize >", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("conn_initsize >=", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeLessThan(Integer value) {
            addCriterion("conn_initsize <", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeLessThanOrEqualTo(Integer value) {
            addCriterion("conn_initsize <=", value, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeIn(List<Integer> values) {
            addCriterion("conn_initsize in", values, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeNotIn(List<Integer> values) {
            addCriterion("conn_initsize not in", values, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeBetween(Integer value1, Integer value2) {
            addCriterion("conn_initsize between", value1, value2, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnInitsizeNotBetween(Integer value1, Integer value2) {
            addCriterion("conn_initsize not between", value1, value2, "connInitsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeIsNull() {
            addCriterion("conn_minsize is null");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeIsNotNull() {
            addCriterion("conn_minsize is not null");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeEqualTo(Integer value) {
            addCriterion("conn_minsize =", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeNotEqualTo(Integer value) {
            addCriterion("conn_minsize <>", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeGreaterThan(Integer value) {
            addCriterion("conn_minsize >", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("conn_minsize >=", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeLessThan(Integer value) {
            addCriterion("conn_minsize <", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeLessThanOrEqualTo(Integer value) {
            addCriterion("conn_minsize <=", value, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeIn(List<Integer> values) {
            addCriterion("conn_minsize in", values, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeNotIn(List<Integer> values) {
            addCriterion("conn_minsize not in", values, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeBetween(Integer value1, Integer value2) {
            addCriterion("conn_minsize between", value1, value2, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMinsizeNotBetween(Integer value1, Integer value2) {
            addCriterion("conn_minsize not between", value1, value2, "connMinsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeIsNull() {
            addCriterion("conn_maxsize is null");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeIsNotNull() {
            addCriterion("conn_maxsize is not null");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeEqualTo(Integer value) {
            addCriterion("conn_maxsize =", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeNotEqualTo(Integer value) {
            addCriterion("conn_maxsize <>", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeGreaterThan(Integer value) {
            addCriterion("conn_maxsize >", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("conn_maxsize >=", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeLessThan(Integer value) {
            addCriterion("conn_maxsize <", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeLessThanOrEqualTo(Integer value) {
            addCriterion("conn_maxsize <=", value, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeIn(List<Integer> values) {
            addCriterion("conn_maxsize in", values, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeNotIn(List<Integer> values) {
            addCriterion("conn_maxsize not in", values, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeBetween(Integer value1, Integer value2) {
            addCriterion("conn_maxsize between", value1, value2, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andConnMaxsizeNotBetween(Integer value1, Integer value2) {
            addCriterion("conn_maxsize not between", value1, value2, "connMaxsize");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIsNull() {
            addCriterion("created_date is null");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIsNotNull() {
            addCriterion("created_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedDateEqualTo(Date value) {
            addCriterion("created_date =", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotEqualTo(Date value) {
            addCriterion("created_date <>", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateGreaterThan(Date value) {
            addCriterion("created_date >", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("created_date >=", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateLessThan(Date value) {
            addCriterion("created_date <", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateLessThanOrEqualTo(Date value) {
            addCriterion("created_date <=", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIn(List<Date> values) {
            addCriterion("created_date in", values, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotIn(List<Date> values) {
            addCriterion("created_date not in", values, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateBetween(Date value1, Date value2) {
            addCriterion("created_date between", value1, value2, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotBetween(Date value1, Date value2) {
            addCriterion("created_date not between", value1, value2, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(String value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotEqualTo(String value) {
            addCriterion("created_by <>", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThan(String value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThanOrEqualTo(String value) {
            addCriterion("created_by >=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThan(String value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThanOrEqualTo(String value) {
            addCriterion("created_by <=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLike(String value) {
            addCriterion("created_by like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotLike(String value) {
            addCriterion("created_by not like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByIn(List<String> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<String> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(String value1, String value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(String value1, String value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateIsNull() {
            addCriterion("updated_date is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateIsNotNull() {
            addCriterion("updated_date is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateEqualTo(Date value) {
            addCriterion("updated_date =", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateNotEqualTo(Date value) {
            addCriterion("updated_date <>", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateGreaterThan(Date value) {
            addCriterion("updated_date >", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("updated_date >=", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateLessThan(Date value) {
            addCriterion("updated_date <", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateLessThanOrEqualTo(Date value) {
            addCriterion("updated_date <=", value, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateIn(List<Date> values) {
            addCriterion("updated_date in", values, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateNotIn(List<Date> values) {
            addCriterion("updated_date not in", values, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateBetween(Date value1, Date value2) {
            addCriterion("updated_date between", value1, value2, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedDateNotBetween(Date value1, Date value2) {
            addCriterion("updated_date not between", value1, value2, "updatedDate");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNull() {
            addCriterion("updated_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNotNull() {
            addCriterion("updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByEqualTo(String value) {
            addCriterion("updated_by =", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotEqualTo(String value) {
            addCriterion("updated_by <>", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByGreaterThan(String value) {
            addCriterion("updated_by >", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByGreaterThanOrEqualTo(String value) {
            addCriterion("updated_by >=", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByLessThan(String value) {
            addCriterion("updated_by <", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByLessThanOrEqualTo(String value) {
            addCriterion("updated_by <=", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByLike(String value) {
            addCriterion("updated_by like", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotLike(String value) {
            addCriterion("updated_by not like", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIn(List<String> values) {
            addCriterion("updated_by in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotIn(List<String> values) {
            addCriterion("updated_by not in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByBetween(String value1, String value2) {
            addCriterion("updated_by between", value1, value2, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotBetween(String value1, String value2) {
            addCriterion("updated_by not between", value1, value2, "updatedBy");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}